SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Endless Potential on a Spacious Lot! This unique property is being sold as-is, offering a blank canvas for you to bring your vision to life. The hard work has been done—the home has been taken down to the framing, allowing you to design and finish it exactly as you please. Whether you're looking to create your dream home or an investment property, the possibilities are endless. Situated on a nice, level, partially fenced-in lot, this property features a two-car garage, a shed, and a front deck, perfect for enjoying your morning coffee or relaxing in the evening. Enjoy the convenience of a prime location in Lebanon, NH, with easy access to Dartmouth-Hitchcock Medical Center, Dartmouth College, and all the amenities of the Upper Valley, while still maintaining privacy and space to make it your own. With the structure in place, all that’s left is your creativity and finishing touches to transform this space into a stunning home. Don’t miss this incredible chance to make 147 Etna Road your own!
Description:161 BANK STREET EXTENSION- This recently renovated 4 bedroom, 2 bath cape is ideally located with close proximity to the Lebanon Green, Middle and High Schools, Dartmouth Hitchcock, Hypertherm and the Rail Trail. The first floor features a newly renovated kitchen and updated first floor bathroom, a comfortable dining and living space, the primary bedroom and a second bedroom which is currently being used as a home office. Upstairs has newly installed flooring, a 3/4 bath and two nice sized bedrooms. A bright three-season porch opens into a recently landscaped backyard with new patio, while the full basement provides ample storage space and potential for additional living area. Additional updates include a new roof, and new front and back doors. A wonderful home in a fantastic location!
Description:Terrific location next to the Pinnacle Trail and just a minute walk to lovely Lyme village, popular restaurants, the Lyme Village Store and the elementary school. Classic cape stye home offers plenty of possibilities for everyone. Three bedrooms, two baths, cheerful living spaces, and cozy family room with wood stove. Beautiful, private, fenced rear yard for gardening and fun. Two car garage all on 1.7 acres.
Description:Spacious Lebanon home having 3-4 bedrooms, 2 baths with a full walk out basement and 1 car garage. Large rooms, first floor laundry and the enclosed side porch is a nice feature. The yard has lilacs and a few trees that make it feel a bit more private, while still in town. Walk the rail trail that is located across the street. Convenient to most everything. Great spot to have a home business also.
Description:Come and see this adorable 2 bedroom, 2 story home! Located on a quiet, private 1.55 acre lot, just 1 lot back from the shores of Lake Mascoma. This home has been fully renovated by the current owners and is a must-see. The detached 2 car garage has a large storage area upstairs, that could be finished for a bonus room, 3rd bedroom, etc. Sit on the flagstone patio and enjoy the view of the Lake and the stream. The boat launch and beach are just down the road for all your swimming, boating and fishing excursions.